SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspCustomerInfo_INSERT
(
@accountId AS int = null,
@cityId AS int = null,
@paymentTypeId AS int = null,
@firstName AS nvarchar(128) = null,
@middleName AS nvarchar(128) = null,
@lastName AS nvarchar(128) = null,
@postIndex AS int = null,
@postAddress AS nvarchar(256) = null,
@phone AS nvarchar(40) = null,
@icq AS int = null,
@skype AS nvarchar(256) = null,
@email AS nvarchar(256) = null,
@createdDate AS datetime = null,
@lastModifiedDate AS datetime = null
)
AS

INSERT INTO
  [dbo].[CustomerInfo]
(
  [AccountId],
  [CityId],
  [PaymentTypeId],
  [FirstName],
  [MiddleName],
  [LastName],
  [PostIndex],
  [PostAddress],
  [Phone],
  [Icq],
  [Skype],
  [Email],
  [CreatedDate],
  [LastModifiedDate]
)
VALUES
(
  @accountId,
  @cityId,
  @paymentTypeId,
  @firstName,
  @middleName,
  @lastName,
  @postIndex,
  @postAddress,
  @phone,
  @icq,
  @skype,
  @email,
  @createdDate,
  @lastModifiedDate
)

SELECT SCOPE_IDENTITY()


GO
